package com.isfto.dao;


import com.isfto.entity.tablepojo.ABRS;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
@Mapper
public interface AbrsDao {
    @Select("select abrs as number,count(*) as value from flightinfoout1  group by abrs having count(*)<2000")
    List<ABRS> abrsInfo();

    @Select("select abrs as number,count(*) as value from flightinfoenter1  group by abrs having count(*)<2000")
    List<ABRS> abrsOutInfo();
}
